IMG
Loading..
Select a color
Solid Color Silk Scarf
Item: TS-SCSS

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
DESCRIPTION

Royal blue 100% silk 8" x 45" solid color scarf. Available in white, black, navy blue, red, maroon, royal blue, hunter green, kelly green, purple, grey, charcoal grey, gold, pink, brown, champagne beige, french blue, lime green, vegas gold, orange and fuchsia. Complimenting tie available. Screen printing, laser etching, laser sheen and pad printing available - 3" x 3" maximum imprint area. Price shown is for the blank item only and does not include decoration.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = 'TS-SCSS') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`